<%@ Page Language="C#" MasterPageFile="~/Admin/Admin.master" AutoEventWireup="true" CodeFile="AddPriceFlight.aspx.cs" Inherits="Admin_AddPriceFlight" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table border="1" bordercolor="#99cccc" 
        style="WIDTH: 614px; HEIGHT: 52px; TEXT-ALIGN: center">
        <tr>
            <td style="WIDTH: 608px; HEIGHT: 104px; TEXT-ALIGN: center">
                <table style="WIDTH: 465px">
                <tr>
            <td colspan="3" style="width: 608px; height: 26px; text-align: center" 
                bgcolor="#5C8BA7">
                <strong><span style="font-size: 16pt">Add Price Flight</span></strong></td>
        </tr>
                    
                    <tr>
                        <td style="HEIGHT: 26px; width: 111px;">
                            FlightID</td>
                                        <td style="HEIGHT: 26px; width: 318px;">
&nbsp;<asp:DropDownList ID="DropDownList1" runat="server" 
        DataSourceID="SqlDataSource2" DataTextField="Flight Name" 
        DataValueField="FlightID">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:sqlString %>" 
        
                                                
                                                SelectCommand="SELECT Airline_Flight.FlightID, '[FROM :] ' + CAST(Airline_Cities.[City Name] AS VARCHAR(50)) + ' [TO :] ' + CAST(Airline_Cities_1.[City Name] AS VARCHAR(50)) + '[AT :] ' + CAST(Airline_Flight.[Depart Time] AS VARCHAR(50)) AS [Flight Name] FROM Airline_Price RIGHT OUTER JOIN Airline_Flight INNER JOIN Airline_Cities INNER JOIN Airline_Route ON Airline_Cities.CityID = Airline_Route.OriginalCityID INNER JOIN Airline_Cities AS Airline_Cities_1 ON Airline_Route.DestinationCityID = Airline_Cities_1.CityID INNER JOIN Airline_Schedule ON Airline_Route.RouteID = Airline_Schedule.RouteID ON Airline_Flight.ScheduleID = Airline_Schedule.SchedueID ON Airline_Price.FlightID = Airline_Flight.FlightID WHERE (Airline_Price.PriceID IS NULL)">
</asp:SqlDataSource>
                                            &nbsp;
                                        </td>
                                    </tr>
                                    <tr>
                                        <td style="HEIGHT: 26px; width: 111px;">
                                            Bussiness class Price</td>
                                        <td style="HEIGHT: 26px; width: 318px;">
                                            &nbsp;<asp:TextBox ID="txtPriceBussiness" runat="server"></asp:TextBox>
                                            <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtPriceBussiness"
                                                ErrorMessage="Please enter Bussiness class Price" SetFocusOnError="True"></asp:RequiredFieldValidator></td>
                                    </tr>
                    <tr>
                        <td style="HEIGHT: 26px; width: 111px;">
                            &nbsp;</td>
                        <td style="HEIGHT: 26px; width: 318px;">
                            &nbsp;</td>
                    </tr>
                    <tr>
                        <td style="HEIGHT: 26px; width: 111px;">
                            First Class Price</td>
                        <td style="HEIGHT: 26px; width: 318px;">
                            <asp:TextBox ID="txtPriceFirst" runat="server"></asp:TextBox>
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="txtPriceFirst"
                                ErrorMessage="Please enter First class Price" SetFocusOnError="True"></asp:RequiredFieldValidator></td>
                    </tr>
                    <tr>
                        <td style="HEIGHT: 26px; width: 111px;">
                            &nbsp;</td>
                        <td style="HEIGHT: 26px; width: 318px;">
                            &nbsp;</td>
                    </tr>
                    <tr>
                        <td style="HEIGHT: 26px; width: 111px;">
                            Club Price
                        </td>
                        <td style="HEIGHT: 26px; width: 318px;">
                            <asp:TextBox ID="txtPriceClub" runat="server"></asp:TextBox>
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="txtPriceClub"
                                ErrorMessage="Please enter Club Price" SetFocusOnError="True"></asp:RequiredFieldValidator></td>
                    </tr>
                    <tr>
                        <td style="HEIGHT: 26px; width: 111px;">
                            &nbsp;</td>
                        <td style="HEIGHT: 26px; width: 318px;">
                            &nbsp;</td>
                    </tr>
                    <tr>
                        <td style="HEIGHT: 26px; width: 111px;">
                            Child Discount</td>
                        <td style="HEIGHT: 26px; width: 318px;">
                            <asp:TextBox ID="txtChildDiscount" runat="server"></asp:TextBox>%&nbsp;
                            <br />
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="txtChildDiscount"
                                ErrorMessage="Please enter ChildDiscount" SetFocusOnError="True"></asp:RequiredFieldValidator>
                            <asp:RangeValidator ID="RangeValidator1" runat="server" ControlToValidate="txtChildDiscount"
                                MaximumValue="100" MinimumValue="0" SetFocusOnError="True" Type="Integer">please enter Discount 0->100</asp:RangeValidator></td>
                    </tr>
                    <tr>
                        <td style="height: 29px; width: 111px">
                        </td>
                        <td style="height: 29px; width: 318px;">
                        </td>
                    </tr>
                    <tr>
                        <td style="height: 25px; width: 111px">
                            Senio Discount</td>
                        <td style="height: 25px; width: 318px;">
                            <asp:TextBox ID="txtSenioDiscount" runat="server"></asp:TextBox>
                            %<br />
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="txtSenioDiscount"
                                ErrorMessage="Please enter SenioDiscount" SetFocusOnError="True"></asp:RequiredFieldValidator>
                            <asp:RangeValidator ID="RangeValidator2" runat="server" ControlToValidate="txtSenioDiscount"
                                ErrorMessage="RangeValidator" MaximumValue="100" MinimumValue="0" SetFocusOnError="True"
                                Type="Integer">Please enter Discount 0->100</asp:RangeValidator></td>
                    </tr>
                    <tr>
                        <td style="HEIGHT: 21px; width: 111px;">
                            &nbsp;</td>
                        <td style="HEIGHT: 21px; width: 318px;">
                            &nbsp;<asp:Button ID="btnAddPrice" runat="server" OnClick="btnAddPrice_Click" Text="Add" />
                            <asp:Label ID="Label2" runat="server"></asp:Label>
                            <asp:Button ID="Button1" runat="server" CausesValidation="False" PostBackUrl="~/Admin/GetFlightList.aspx"
                                Text="Cancel" /></td>
                    </tr>
                </table>
                &nbsp;
            </td>
        </tr>
    </table>
</asp:Content>

